Show All

Display or hide sheet tabs

Display or hide all sheet tabs

1. On the Tools menu, click Options, and then click the View tab.
2. Select or clear the Sheet tabs check box. When displaying sheet tabs, you may also need to expand the tab scrolling area.

   

Display more or fewer sheet tabs

1. Point to the tab split bar.

   

2. When the pointer changes to a split pointer , drag the tab split bar to the right or left.

   To return the tab split bar to its original position, double-click the tab split bar.

   Tip

   You can activate a sheet by right-clicking any tab scrolling button and then selecting the sheet you want from the shortcut menu.

If the sheet names are cut off or difficult to read